
alter table jms_dm.dm_tab_missrate_trace_waybill_next_dt
    set tblproperties ('external.table.purge' = 'true');
drop table jms_dm.dm_tab_missrate_trace_waybill_next_dt;
create external table jms_dm.dm_tab_missrate_trace_waybill_next_dt
(
    date_time                        string comment '日期',
    waybill_no                       string comment '运单',
    first_code                       string comment '一段码',
    second_code                      string comment '二段码',
    third_code                       string comment '三段码',
    send_station_network_code        string comment '发件站点',
    send_station_network_type        string comment '发件站点类型',
    send_station_send_later_time     string comment '发件站点时间',
    sent_station_send_packagecode    string comment '发件站点运单对应包号',
    send_station_next_station        string comment '发件站点下一站',
    send_station_next_statation_type string comment '发件站点下一站类型',
    next_station_arrival_early_time  string comment '下一站到件时间',
    deliver_later_user               string comment '扫描员',
    instore_early_scantime           string comment '入库时间',
    instore_early_scansitecode       string comment '入库网点',
    outstore_early_scantime          string comment '出库时间',
    outstore_early_scansitecode      string comment '出库网点',
    sign_early_scantime              string comment '签收时间',
    sign_early_scansitecode          string comment '签收网点',
    next_next_network_code           string comment '下下一站',
    next_next_code_type              string comment '下下一站类型',
    next_next_arrival_early_time     string comment '下下一站到件时间',
    remark2                          string comment '备用',
    remark3                          string comment '备用',
    remark4                          string comment '备用',
    remark5                          string comment '备用'

) COMMENT '错分下一站'
    PARTITIONED BY ( dt STRING COMMENT 't-1')
    STORED AS PARQUET
    LOCATION '/dw/hive/jms_dm.db/external/dm_tab_missrate_trace_waybill_next_dt'
;

